﻿CREATE TABLE [dbo].[tblCarrierZoneRate]
(
	CarrierID int not null,
	Zone varchar(2) not null,
	[Weight] float not null,
	[Rate] money not null,
	primary key ( CarrierID, Zone, [Weight] )
)
go;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Links a carrier, zone, and weight to a postal rate.  Each carrier defines their rates by service, zone and weight.', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblCarrierZoneRate';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The CarrierID defines the carrier and service', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblCarrierZoneRate',
	@level2type = N'COLUMN', @level2name = N'CarrierID';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The CarrierID defines the carrier and service', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblCarrierZoneRate',
	@level2type = N'COLUMN', @level2name = N'Zone';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The CarrierID defines the carrier and service', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblCarrierZoneRate',
	@level2type = N'COLUMN', @level2name = N'Weight';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The CarrierID defines the carrier and service', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblCarrierZoneRate',
	@level2type = N'COLUMN', @level2name = N'Rate';
